Using the Measures Tree
The measures tree displays the data model's measures (quantitative data); from here, you can add measures to the query. The measure panel also exposes a number of other functions, and you can add a metadata overlay to measures by editing their properties.
Add Measures to the Query
Measures are added to the query primarily via the value drop zones, however it can be used in other ones like color, size, labels, tooltips and trellising. Each drop zone drives a corresponding component in the visualization. When multiple measure are added, the Value chip is generated. The given measures will remain in the Values zone, while the Values chip can be placed wherever required. The placement of the Values chip drives the location of the measures in the visualization.
- Click here to learn more about the drop zones.
- Click here to learn more about the Values drop zone.
There are several ways to add measures from the Measure Tree to the query.
Select
Simply select the checkbox of the measures you want to add to the query. Pyramid will add the selected measures to the drop zones automatically.
Double Click
Double click on the measure you want to add to the query. Pyramid will add the selected measures to the drop zones automatically.
Context Menu "Add To"
Right click on the measure; from the context menu go to Add To and choose the drop zone that you want to add the measure to.
Drag and Drop
Drag the measure from the Measure Tree; this will expose the drop zone icons in the middle of the page. You can drop the measure onto a drop zone icon, or directly onto the drop zone panel.
Select Highlights
To add multiple measures at once, hold the Shift or Ctrl keys and then click on the measure caption (NOT the measure checkbox). The selected measures will be highlighted orange (as shown below). Right click on one of the highlighted measures and click Select Highlights.
Moving Measures in the Drop Zones
Once measures are added to drop zones (and are in the query), they can be shifted around.
Drag and Drop
Move measures between the drop zones simply by dragging and dropping them.
Move To
Right click on a measure in the drop zone and go to Move To; select the required drop zone.
Copy Measures
Add the same measure to multiple drop zones using the following techniques by drag and dropping it or using the Add To method (both listed above). You can also use the Copy To function from the context menu (as described below).
Right click on the measure chip in the Drop Zone; go to Copy To and select the required drop zone.
Removing Measures from the Query
There are several methods to remove measure chips from the drop zones.
Measure Tree
Uncheck
Deselect the measure's checkbox in the Measure Tree.
Deselect All
Click the Deselect button to deselect all currently selected measures.
Deselect Highlights
Remove multiple measures from the query at once Shift or Ctrl + selecting (click on the measure caption, NOT the measure checkbox); the selected measures will be highlighted orange. Right click on one of the highlighted measures and click Deselect Highlights.
Drop Zones
Delete
Click the " x " on the measure chip in drop zone.
Right Click Context Menu
Right click on the measure chip in the drop zone and click Remove.